09/09/2021

Introduction

Jonathan

The Team

  • Derek - Life Expectancy SME
  • John Paul - Smoking SME
  • JP - Drug Abuse SME
  • Prathiba - R Shiny Dashboard Architect
  • Paddy - Spatial Data Guru

Key findings - Life expectancy

Derek

The Data

  • What is life expectancy and why it was chosen?

Life expectancy is a statistical measure of the average time an organism is expected to live, based on the year of its birth, its current age and any other demographic factors including sex and geographic area.

  • The source of the data

statistics.gov.uk

  • Why was this data selected?

Trend - Dumfries & Galloway

Trend - Scotland

Rank

  • Overview
  • [plot placeholder]
  • Findings / key areas for business to focus on / disparity between areas

Key findings - Smoking

John Paul

The data

  • The data set used for this was: Smoking - Scottish Survey Core Questions

  • The data was sourced from: https://statistics.gov.scot/resource?uri=http%3A%2F%2Fstatistics.gov.scot%2Fdata%2Fsmoking-sscq

  • Why it was chosen Originally, Mental Wellbeing was selected for the project but the data quantity was not enough for our purposes. We chose Smoking as two of the Scottish Government’s National Performance Framework (NPF) National Indicators are relevant to smoking. There is a strong Public Health focus on reducing the proportion of adults who smoke.

Trend

  • Overview The overview is generally optimistic. Whilst numbers are still higher than anyone would like, the long term trend shows a steady reduction in all age groups, especially the youngest age group of 16-35.

  • [plot placeholder]

  • Findings / key demographic for business to focus on

Rank

  • Overview
  • Plot
  • Findings / key areas for business to focus on / disparity between areas

Map

  • Overview There are huge variations around the country, whether they be measured by NHS Health Board or the more granular Local Authority areas. Poverty is one factor along with an urban/rural divide. Essentially the areas with the lowest proportion of smokers are more rural, and more affluent. The opposite is also true.

  • Findings / key areas for business to focus on More work needs to be in less affluent areas, especially in the traditional industrial areas, to further reduce the rate of smoking.

Key findings - Drug abuse

Jonathan

The data

  • Scottish Drug Misuse Database
  • https://www.opendata.nhs.scot/
  • Published by Public Health Scotland - the national public health body for Scotland
  • Why was this data selected?

Trend by gender

Trend by age group

Rank

Conclusion

Jonathan

  • Recap brief
  • Recap of the main focus points for each of the three areas

Dashboard Demonstration

Prathiba & Paddy

Questions